Generating data warehouse tasks

After the data warehouse tables have been created, you then need to generate the task that will be used in the data warehouse task. The task contains the Mappings ETL (which is automatically created) and any custom ETLs that you have defined. If you need to make changes to the Mappings or define custom ETLs, continue from Managing tasks and Creating and managing custom ETLs respectively.

You can either generate individual tasks or you can generate multiple tasks concurrently.

To generate a single data warehouse task:

1. Click the Manage button in the bottom left of the Data Warehouse panel. The Manage Data Warehouse Tasks window opens.

2. If you have more than one task, in the left pane, select the task that you want to generate.

3. Do one of the following:

   • To generate the task with basic validations, click the Generate toolbar button.

     By default, Compose generates the task with basic validations. Basic validations are suitable for most tasks, but are especially useful for tasks with numerous expressions and lookups, as generating such tasks with all validations could take a long time.

   • To generate the task with all validations, click the inverted triangle to the right of the Generate button and select With all validations from the drop-down menu.

     All validations includes validations that access the database to verify the existence of columns used in expressions and lookups. As selecting With all validations will significantly lengthen the time it takes to generate the task, you should only select it if it's critical to verify that existence of such columns before the tasks starts.

   The Generating task for <Name> progress window opens. When the "Generate task finished successfully" message is displayed, close the window.

   Information note

   Only mappings selected in the Manage Data Warehouse Tasks window will be generated.

To generate multiple data warehouse tasks:

1. Click the Manage button in the bottom left of the Data Warehouse panel. The Manage Data Warehouse Tasks window opens.

2. Click the inverted triangle to the right of the Generate toolbar button and select Bulk from the drop-down menu.

   The Bulk Generate dialog opens.

3. Select the tasks you want to generate.

4. Optionally, change the task validation level:

   • With basic validations: By default, Compose generates tasks with basic validations. Basic validations are suitable for most tasks, but are especially useful for tasks with numerous expressions and lookups, as generating such tasks with all validations could take a long time.

   • With all validations: This includes validations that access the database to verify the existence of columns used in expressions and lookups. As selecting All validations will significantly lengthen the time it takes to generate the task, you should only select it if it's critical to verify that existence of such columns before the tasks starts.

5. Click the OK to start the task generation.

   Information note

   Only mappings selected in the Manage Data Warehouse Tasks window will be generated.